Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 11

You can enter which types of data into worksheet cells?

a) Labels, values, and formulas

b) Labe31s and values but not formulas

c) Values and formulas but not labels

d) Formulas only

e) None of these

Question : 12

Which menu option can be used to split windows into two

a) View > window > split

b) Format > window

c) Window > split

d) View > split

e) None of these

Question : 13

What Is entered by the function •today ()

a) The date value for the day according to system clock

b) The time value according to system clock

c) Today's date as Text format

d) All of above

e) None of these

Question : 14

To copy cell contents using drag and drop press the

a) End key

b) Shift key

c) Ctrl key

d) Esc key

e) None of these

Question : 15

Ctrl +p shortcut key in Excel will

a) Open the font dialog box

b) Apply double underline for the active cell

c) Fill down in the selection

d) All of above

e) None of these